class AddFieldsToUser < ActiveRecord::Migration
  def self.up
  	add_column :users, :url, :string, :limit=>"50"
  	add_column :users, :birthday, :datetime
  	add_column :users, :icq, :string, :limit=>"30"
  	add_column :users, :status, :string
  	add_column :users, :description, :string
  	add_column :users, :country_id, :integer
  	add_column :users, :city_id, :integer
  	add_column :users, :city_name, :string, :limit=>"50"
  	
  	add_index :users, :country_id
  	add_index :users, :city_id
  end

  def self.down
  	remove_column :users, :url
  	remove_column :users, :birthday
  	remove_column :users, :icq
  	remove_column :users, :status
  	remove_column :users, :description
  	remove_column :users, :country_id
  	remove_column :users, :city_id
  	remove_column :users, :city_name
  end
end
